import pandas as pd
list=[[110,120,105],[95,110,108],[98,80,100],[112,106,97]]
index=["王蒙",'李珊','赵胜','刘文']
columns=['语文','数学','英语']
df=pd.DataFrame(list,index,columns)
print('保存到 “scorel” 工作表种的数据:\n',df)
writre = pd.ExcelWriter('Score.xlsx')
df.to_excel(writre,sheet_name='score1')
df.iloc[0] = [105,118,110]
df.to_excel(writre,sheet_name='score2')
writre._save()
df1 = pd.read_excel('Score.xlsx',sheet_name=['score1','score2'],index_col=0)
print('导入的数据:\n',df1)